reminder
Table: reminder
The reminder table stores system reminders with scheduling details.
It is used to manage automated notifications and user-defined reminders.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| reminderId | smallint(6) | NOT NULL, PRIMARY KEY, AUTO_INCREMENT | Unique identifier for each reminder |
| createdDate | datetime | DEFAULT NULL | Timestamp when the reminder was created |
| description | varchar(255) | DEFAULT NULL | Optional description of the reminder |
| lastEditedDate | datetime | DEFAULT NULL | Timestamp when the reminder was last edited |
| remindername | varchar(255) | NOT NULL, UNIQUE | Name of the reminder |
| createdByUserId | int(11) | DEFAULT NULL | User who created the reminder |
| lastEditedByUserId | int(11) | DEFAULT NULL | User who last edited the reminder |
| defaultReminderTime | time | DEFAULT NULL | Default time for sending the reminder |
| gapEventDay | smallint(6) | NOT NULL | Gap in days related to the event triggering the reminder |
| isDefaultTimeEditable | tinyint(1) | DEFAULT NULL | Flag indicating if default time can be edited (1 = yes, 0 = no) |
| reminderType | varchar(50) | DEFAULT NULL | Type/category of the reminder |
Indexes
- PRIMARY: Primary key on
reminderId - UNIQUE: Unique index on
remindername reminder_lastEditedByUserId_user_mappedId_FK: Index onlastEditedByUserIdreminder_createdByUserId_user_mappedId_FK: Index oncreatedByUserId
Foreign Key Relations
createdByUserId→user.mappedIdlastEditedByUserId→user.mappedId
Usage Notes
- Stores reminders for system notifications or events.
gapEventDaycontrols the delay between the event and the reminder.isDefaultTimeEditableallows admin control over default reminder timings.- Linked to
usertable to track creation and modification.